This model dimension represents the Group Consolidation structure node and is based on the IFS Cloud dimension DIM_CONSOL_STRUCTURE_NODE. All models that refers to this dimension will have the attributes and hierarchies as described below.
Natural parent is company and structure, i.e. each master company structure has its own set of structure node values.
| Attribute | Description (where applicable) |
| Child Type | Child Type |
| Company Code | Company Code |
| Structure | Structure ID |
| Structure - Code - Desc | Built as STRUCTURE ID + ' - ' +CODE + ' - ' + DESCRIPTION |
| Structure Node | Structure Node |
| Structure Node Code | Represents the CODE of the dimension, i.e. Structure Node Code value |
| Structure Node Code Desc | Built as CODE + ' - ' + DESCRIPTION |
| Structure Node Desc | Represents the DESCRIPTION of the Structure Node value |
| Structure Node Type | Represents the node type of the Structure Node |
| Hierarchy | Level |
| StructureNodeHy | |
| Structure | |
| Structure Node Code Desc |
| Model Name |
| Group Consolidation |
The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| STRUCTURE NODE | DIM_CONSOL_STRUCTURE_NODE_GC_TM | CONSOL_STRUCT_NODE_SORT_ID_BIA | CONSOL_STRUCT_NODE_SORT_ID_BIA | On Line |